package com.water.dmdb.db;

import com.water.dmdb.util.DbUtil;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

public class PoolTest {
    /**
     * 测试数据库连接池
     *
     * @param args
     */
    @SuppressWarnings("all")
    public static void main(String[] args) throws SQLException {

        String sql = " create table student(id int ,name varchar(20),sex varchar(2),primary key(id))";

        String sql1 = "INSERT INTO \"TEST\".\"TEST_TABLE\" (\"id\", \"A\", \"B\", \"C\", \"D\", \"E\", \"F\", \"G\") VALUES ('[BFILE] (DATA_PUMP_DIR, 111) (NOT EXIST)', '11.000000000000000', '11.0000000', NULL, '11          ', '1', TO_DATE('2021-09-13 11:49:24', 'SYYYY-MM-DD HH24:MI:SS'), '1'); commit";
//        List<Map<String, Object>> list1 = DbUtil.execute(sql, DbUtil.DbType.DM);
        for (int i = 0; i < 1000; i++) {
            List<Map<String, Object>> list2 = DbUtil.execute(sql1, DbUtil.DbType.ORACLE);
        }
        System.out.println();

    }

}
